const insertServicse = require("../servicse/muchtab")
const select = async (req, res) => {
    let sql = `SELECT a.commoditycoding,a.commodityname,a.barcode,b.category,a.model,d.suppliername,a.brand,e.measurename,c.warehousename,
    a.wholesaleprice,a.retailprice,a.start
    FROM commodity a,commoditycategory b,warehousecategory c,supplier d,unitofmeasurement e
    WHERE a.category=b.id AND a.warehouse=c.warehousenumber AND a.supplier=d.suppliernumber AND a.metering=e.id`;
    let routs = await insertServicse.selectmore(sql);
    res.send(routs);
}
module.exports = {
    select
}